Text: MID Function Arguments
The MID Function has three Arguments:
.Text is the Cell that has the text string.
Start-num in the number of characters (including punctuation and spaces) between the beginning of the text string and the data that you want. In our example, the Month has 3 characters (Jan, Feb, etc.) and there is a comma and a space before the Category (Private, Educational, etc.).
Num_chars is the number of characters you want Excel to return. You can enter a number larger than the characters in the remainder of the string. Excel ignores the Num_chars that are empty (null.)
2. Try it: Edit the MID Function Arguments
Text: K2
Start_num: 5
Num_chars: 30
There will be a preview: Private, Cold Platter.
Click OK.
Do This, Too: Copy the MID Function
Select Cell L2.
Copy Cell L2 and paste the MID Function into CellsL3:L69.
Keep going...
